Importing from Excel

You can import user-defined properties for technical assets from an XLSX file. You can either use an existing XLSX file or download an extended properties file from the Extended Properties tab. Ensure that the XLSX file follows the correct template.

To import extended properties from XLSX files, follow these steps:

  1. On the Extended Properties tab, click Import From Excel.

    2. The Upload Excel page appears.
    Upload Excel Page Ep

  2. Click Choose File.
  3. Browse and select the XLSX file.
  4. Click Icon Import Data.

    5. The Upload Excel page appears. It displays the data in the XLSX file.

    Upload Excel Data Fields

  5. Double-click the Select Column To Import cell in the required column.

    6. The available options appear.

    Upload Excel Data Select

  6. Select an appropriate option.

    7. For example, if you select Field, then the selected column is imported as Field.

    Similarly, you can also select the Value, Type, and Parentfield columns. Ensure that you at least select a Field column.

  7. Click Icon Import Data.

    8. The extended properties are imported.

    Extended Properties Imported Excel